﻿USE [RestaurantManagement]
GO
SET ANSI_NULLS ON
GO
SET QUOTED_IDENTIFIER ON
GO
-- =============================================
-- Author:		<Nguyễn Đức Thắng>
-- Create date: <15/03/2013>
-- =============================================
CREATE procedure [dbo].[Update_RestaurantMenuCategory]
		@MenuCategoryID as uniqueidentifier,
		@MenuCategoryCode as varchar(20),
		@IsParent as bit,
		@ParentID as uniqueidentifier,
		@MenuCategoryName as nvarchar(255),
		@Description as nvarchar(255),
		@IsActive as bit,
		@RestaurantID as uniqueidentifier
AS 
		update dbo.[RestaurantMenuCategory] set 
			MenuCategoryID= @MenuCategoryID,
			MenuCategoryCode= @MenuCategoryCode,
			IsParent= @IsParent,
			ParentID= @ParentID,
			MenuCategoryName= @MenuCategoryName,
			Description= @Description,
			IsActive= @IsActive,
			RestaurantID= @RestaurantID
		 where 	(@MenuCategoryID=dbo.[RestaurantMenuCategory].MenuCategoryID)

GO
